select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (a.houseprice >= 30000 and a.houseprice <= 40000) and (a.houseArea >= 100 and a.houseArea <= 200) and c.enDistrictName = 'Xuhui' and b.pid in (select x.pid from [base_property] x,[base_districtArea] y where x.aid=y.id and y.enAreaName = 'Former French Concession') order by updateTime Desc, a.dftpic desc
Very nice with high quality design, brand newly renovated, wall heating, centre ac, full furnished, 3bedrooms with extra storage room, masterbedroom with walkin...